Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# XMLPARSE

Syntax

Description of the illustration XMLParse.gif

Purpose

`XMLParse` parses and generates an XML instance from the evaluated result of `value_expr`. The `value_expr` must resolve to a string. If `value_expr` resolves to null, then the function returns null.

- If you specify `DOCUMENT`, then `value_expr` must resolve to a singly rooted XML document.

- If you specify `CONTENT`, then `value_expr` must resolve to a valid XML value.

- When you specify `WELLFORMED`, you are guaranteeing that `value_expr` resolves to a well-formed XML document, so the database does not perform validity checks to ensure that the input is well formed.

See Also: Oracle XML DB Developer's Guide for more information on this function

Examples

The following example uses the `DUAL` table to illustrate the syntax of `XMLParse`:

    SELECT XMLPARSE(CONTENT '124 <purchaseOrder poNo="12435">
       <customerName> Acme Enterprises</customerName>
       <itemNo>32987457</itemNo>
       </purchaseOrder>'
    WELLFORMED) AS PO FROM DUAL;

    PO
    -----------------------------------------------------------------
    124 <purchaseOrder poNo="12435">
       <customerName> Acme Enterprises</customerName>
       <itemNo>32987457</itemNo>
       </purchaseOrder>